How to: Move data in a table.
Solution:
Open the Table Datasheet view, select and cut an entry or part of an entry, and paste it to a new location within the same table.
1) If the Database window is not active, activate the Database window.
2) Open the Table Datasheet view.
3) Do one of the following to select what will be moved:
a) To move an entire cell entry, select only that cell. (The cell is highlighted.)
Entire cell selected
b) To move part of a cell entry, select (highlight) only the portion of the entry to be moved by clicking and dragging the mouse over it.
Part of cell entry selected
4) Select the 'Edit' menu and select 'Cut'. (The selected information is copied to the Clipboard.)
5) Move the cursor to where the data is to be moved.
NOTE: If an entire cell was selected in step 3), select an entire cell to which to paste the data.
6) Select the 'Edit' menu and select 'Paste'.
7) Select the 'File' menu and select 'Save' to save changes.
8) Select the 'File' menu and select 'Close' to close the Table Datasheet view. (The Table Datasheet view closes, and changes are saved automatically if not already saved.)
